USE [IstoreInternet]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[InsertOrderItem]
	@productId int,
	@orderId int,
	@orderItemQuantity int,
	@orderItemPrice decimal(9, 2),
	@RMANumber nvarchar(50),
	@RMAIssuedBy nvarchar(50),
	@RMAIssuedDate datetime
AS
BEGIN
	SET NOCOUNT ON;

    INSERT INTO dbo.OrderItem (productId, orderId, orderItemQuantity, orderItemPrice, RMANumber, RMAIssuedBy, RMAIssuedDate) 
    VALUES (@productId, @orderId, @orderItemQuantity, @orderItemPrice, @RMANumber, @RMAIssuedBy, @RMAIssuedDate);
    
END




GO


